Tabela CO_CATERINGORDER

Definicja tabeli CO_CATERINGORDER

Name

CO_CATERINGORDER

Code

CO_CATERINGORDER

Comment

 


Lista kolumn tabeli CO_CATERINGORDER

Name

Code

CO_CATERINGORDERID

CO_CATERINGORDERID

ORDERDT

ORDERDT

DATEFROM

DATEFROM

DATETO

DATETO

CLIENTNAME

CLIENTNAME

CLIENTADDRESS

CLIENTADDRESS

CLIENTNIP

CLIENTNIP

STATUS

STATUS

GUESTCOUNT

GUESTCOUNT

COMMENTS

COMMENTS

CO_STOREDOCUMENTID

CO_STOREDOCUMENTID

INSERTDATE

INSERTDATE

INSERTINGPERSON

INSERTINGPERSON

LASTMODIFIEDPERSON

LASTMODIFIEDPERSON

LASTMODIFIEDDT

LASTMODIFIEDDT


Kolumna CO_CATERINGORDERID tabeli CO_CATERINGORDER

Definicja kolumny CO_CATERINGORDERID tabeli CO_CATERINGORDER

Name

CO_CATERINGORDERID

Code

CO_CATERINGORDERID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ORDERDT tabeli CO_CATERINGORDER

Definicja kolumny ORDERDT tabeli CO_CATERINGORDER

Name

ORDERDT

Code

ORDERDT

Data Type

DATE

Mandatory

Yes

Comment

 


Kolumna DATEFROM tabeli CO_CATERINGORDER

Definicja kolumny DATEFROM tabeli CO_CATERINGORDER

Name

DATEFROM

Code

DATEFROM

Data Type

DATE

Mandatory

Yes

Comment

 


Kolumna DATETO tabeli CO_CATERINGORDER

Definicja kolumny DATETO tabeli CO_CATERINGORDER

Name

DATETO

Code

DATETO

Data Type

DATE

Mandatory

Yes

Comment

 


Kolumna CLIENTNAME tabeli CO_CATERINGORDER

Definicja kolumny CLIENTNAME tabeli CO_CATERINGORDER

Name

CLIENTNAME

Code

CLIENTNAME

Data Type

VARCHAR2(255)

Mandatory

Yes

Comment

 


Kolumna CLIENTADDRESS tabeli CO_CATERINGORDER

Definicja kolumny CLIENTADDRESS tabeli CO_CATERINGORDER

Name

CLIENTADDRESS

Code

CLIENTADDRESS

Data Type

VARCHAR2(255)

Mandatory

Yes

Comment

 


Kolumna CLIENTNIP tabeli CO_CATERINGORDER

Definicja kolumny CLIENTNIP tabeli CO_CATERINGORDER

Name

CLIENTNIP

Code

CLIENTNIP

Data Type

VARCHAR2(20)

Mandatory

Yes

Comment

 


Kolumna STATUS tabeli CO_CATERINGORDER

Definicja kolumny STATUS tabeli CO_CATERINGORDER

Name

STATUS

Code

STATUS

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna GUESTCOUNT tabeli CO_CATERINGORDER

Definicja kolumny GUESTCOUNT tabeli CO_CATERINGORDER

Name

GUESTCOUNT

Code

GUESTCOUNT

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna COMMENTS tabeli CO_CATERINGORDER

Definicja kolumny COMMENTS tabeli CO_CATERINGORDER

Name

COMMENTS

Code

COMMENTS

Data Type

VARCHAR2(255)

Mandatory

Yes

Comment

 


Kolumna CO_STOREDOCUMENTID tabeli CO_CATERINGORDER

Definicja kolumny CO_STOREDOCUMENTID tabeli CO_CATERINGORDER

Name

CO_STOREDOCUMENTID

Code

CO_STOREDOCUMENTID

Data Type

NUMBER(38)

Mandatory

No

Comment

 


Kolumna INSERTDATE tabeli CO_CATERINGORDER

Definicja kolumny INSERTDATE tabeli CO_CATERINGORDER

Name

INSERTDATE

Code

INSERTDATE

Data Type

DATE

Mandatory

No

Comment

 


Kolumna INSERTINGPERSON tabeli CO_CATERINGORDER

Definicja kolumny INSERTINGPERSON tabeli CO_CATERINGORDER

Name

INSERTINGPERSON

Code

INSERTINGPERSON

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna LASTMODIFIEDPERSON tabeli CO_CATERINGORDER

Definicja kolumny LASTMODIFIEDPERSON tabeli CO_CATERINGORDER

Name

LASTMODIFIEDPERSON

Code

LASTMODIFIEDPERSON

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna LASTMODIFIEDDT tabeli CO_CATERINGORDER

Definicja kolumny LASTMODIFIEDDT tabeli CO_CATERINGORDER

Name

LASTMODIFIEDDT

Code

LASTMODIFIEDDT

Data Type

DATE

Mandatory

No

Comment

 


Lista kluczy tabeli CO_CATERINGORDER

Name

Code

Primary

PK_CO_CATERINGORDER

PK_CO_CATERINGORDER

X


Klucz PK_CO_CATERINGORDER tabeli CO_CATERINGORDER

Definicja klucza PK_CO_CATERINGORDER tabeli CO_CATERINGORDER

Name

PK_CO_CATERINGORDER

Code

PK_CO_CATERINGORDER

Primary

Yes

Comment